Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	8950
Missing cells	314
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 MiB
Average record size in memory	144.0 B

Variable types

NUM	17
CAT	1

Reproduction

Analysis started	2020-06-16 04:16:56.425065
Analysis finished	2020-06-16 04:18:11.323800
Duration	1 minute and 14.9 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`ONEOFF_PURCHASES` is highly correlated with `PURCHASES`	High correlation
`PURCHASES` is highly correlated with `ONEOFF_PURCHASES`	High correlation
`MINIMUM_PAYMENTS` has 313 (3.5%) missing values	Missing
`CUST_ID` has unique values	Unique
`PURCHASES` has 2044 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES` has 4302 (48.1%) zeros	Zeros
`INSTALLMENTS_PURCHASES` has 3916 (43.8%) zeros	Zeros
`CASH_ADVANCE` has 4628 (51.7%) zeros	Zeros
`PURCHASES_FREQUENCY` has 2043 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES_FREQUENCY` has 4302 (48.1%) zeros	Zeros
`PURCHASES_INSTALLMENTS_FREQUENCY` has 3915 (43.7%) zeros	Zeros
`CASH_ADVANCE_FREQUENCY` has 4628 (51.7%) zeros	Zeros
`CASH_ADVANCE_TRX` has 4628 (51.7%) zeros	Zeros
`PURCHASES_TRX` has 2044 (22.8%) zeros	Zeros
`PAYMENTS` has 240 (2.7%) zeros	Zeros
`PRC_FULL_PAYMENT` has 5903 (66.0%) zeros	Zeros

CUST_ID
Categorical

UNIQUE

Distinct count	8950
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	69.9 KiB

C15411	1
C15360	1
C14786	1
C18220	1
C11450	1
Other values (8945)	8945

Common Values
Length

Value	Count	Frequency (%)
C15411	1	< 0.1%
C15360	1	< 0.1%
C14786	1	< 0.1%
C18220	1	< 0.1%
C11450	1	< 0.1%
C10753	1	< 0.1%
C15295	1	< 0.1%
C15309	1	< 0.1%
C11264	1	< 0.1%
C13292	1	< 0.1%
Other values (8940)	8940	99.9%

Length

Max length	6
Median length	6
Mean length	6
Min length	6

BALANCE
Real number (ℝ_≥0)

Distinct count	8871
Unique (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1564.4748276781006
Minimum	0.0
Maximum	19043.13856
Zeros	80
Zeros (%)	0.9%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	8.81451835
Q1	128.2819155
median	873.385231
Q3	2054.140036
95-th percentile	5909.111808
Maximum	19043.13856
Range	19043.13856
Interquartile range (IQR)	1925.85812

Descriptive statistics

Standard deviation	2081.531879
Coefficient of variation (CV)	1.330498799
Kurtosis	7.6747513
Mean	1564.474828
Median Absolute Deviation (MAD)	799.865197
Skewness	2.393386043
Sum	14002049.71
Variance	4332774.965

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	80	0.9%
1100.941072	1	< 0.1%
40.074484	1	< 0.1%
2093.844656	1	< 0.1%
179.765708	1	< 0.1%
12.654903	1	< 0.1%
1893.704851	1	< 0.1%
1571.218695	1	< 0.1%
31.285608	1	< 0.1%
1772.323491	1	< 0.1%
Other values (8861)	8861	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%

BALANCE_FREQUENCY
Real number (ℝ_≥0)

Distinct count	43
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8772707255865921
Minimum	0.0
Maximum	1.0
Zeros	80
Zeros (%)	0.9%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.2369040027
Coefficient of variation (CV)	0.2700466296
Kurtosis	3.092369622
Mean	0.8772707256
Median Absolute Deviation (MAD)	0
Skewness	-2.023265519
Sum	7851.572994
Variance	0.05612350649

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.4%
0.636364	209	2.3%
0.454545	172	1.9%
0.363636	170	1.9%
0.272727	151	1.7%
0.181818	146	1.6%
Other values (33)	761	8.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.7%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%

PURCHASES
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	6203
Unique (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1003.2048335195531
Minimum	0.0
Maximum	49039.57
Zeros	2044
Zeros (%)	22.8%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.635
median	361.28
Q3	1110.13
95-th percentile	3998.6195
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1070.495

Descriptive statistics

Standard deviation	2136.634782
Coefficient of variation (CV)	2.129809098
Kurtosis	111.3887709
Mean	1003.204834
Median Absolute Deviation (MAD)	361.28
Skewness	8.144269065
Sum	8978683.26
Variance	4565208.191

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2044	22.8%
45.65	27	0.3%
150	16	0.2%
60	16	0.2%
100	13	0.1%
300	13	0.1%
200	13	0.1%
450	12	0.1%
600	10	0.1%
70	10	0.1%
Other values (6193)	6776	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%

ONEOFF_PURCHASES
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	4014
Unique (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	592.4373709497207
Minimum	0.0
Maximum	40761.25
Zeros	4302
Zeros (%)	48.1%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	577.405
95-th percentile	2671.094
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	577.405

Descriptive statistics

Standard deviation	1659.887917
Coefficient of variation (CV)	2.801794753
Kurtosis	164.187572
Mean	592.4373709
Median Absolute Deviation (MAD)	38
Skewness	10.04508288
Sum	5302314.47
Variance	2755227.898

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	4302	48.1%
45.65	46	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
70	12	0.1%
150	12	0.1%
1000	12	0.1%
250	11	0.1%
Other values (4004)	4497	50.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%

INSTALLMENTS_PURCHASES
Real number (ℝ_≥0)

ZEROS

Distinct count	4452
Unique (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	411.0676446927374
Minimum	0.0
Maximum	22500.0
Zeros	3916
Zeros (%)	43.8%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	468.6375
95-th percentile	1750.0875
Maximum	22500
Range	22500
Interquartile range (IQR)	468.6375

Descriptive statistics

Standard deviation	904.3381152
Coefficient of variation (CV)	2.199973963
Kurtosis	96.57517753
Mean	411.0676447
Median Absolute Deviation (MAD)	89
Skewness	7.299119909
Sum	3679055.42
Variance	817827.4266

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3916	43.8%
100	14	0.2%
300	14	0.2%
200	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
225	8	0.1%
350	8	0.1%
450	8	0.1%
Other values (4442)	4936	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3916	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%

CASH_ADVANCE
Real number (ℝ_≥0)

ZEROS

Distinct count	4323
Unique (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	978.8711124654749
Minimum	0.0
Maximum	47137.211760000006
Zeros	4628
Zeros (%)	51.7%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.821139
95-th percentile	4647.169122
Maximum	47137.21176
Range	47137.21176
Interquartile range (IQR)	1113.821139

Descriptive statistics

Standard deviation	2097.163877
Coefficient of variation (CV)	2.142431062
Kurtosis	52.89943411
Mean	978.8711125
Median Absolute Deviation (MAD)	0
Skewness	5.166609074
Sum	8760896.457
Variance	4398096.325

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	4628	51.7%
1286.356207	1	< 0.1%
3816.470266	1	< 0.1%
2495.298926	1	< 0.1%
748.241727	1	< 0.1%
1572.492719	1	< 0.1%
5425.912807	1	< 0.1%
9553.955906	1	< 0.1%
341.360876	1	< 0.1%
1424.442602	1	< 0.1%
Other values (4313)	4313	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%

PURCHASES_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct count	47
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.49035054837988823
Minimum	0.0
Maximum	1.0
Zeros	2043
Zeros (%)	22.8%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.4013707474
Coefficient of variation (CV)	0.8185383879
Kurtosis	-1.638630948
Mean	0.4903505484
Median Absolute Deviation (MAD)	0.416667
Skewness	0.06016423586
Sum	4388.637408
Variance	0.1610984768

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	2178	24.3%
0	2043	22.8%
0.083333	677	7.6%
0.916667	396	4.4%
0.5	395	4.4%
0.166667	392	4.4%
0.833333	373	4.2%
0.333333	367	4.1%
0.25	345	3.9%
0.583333	316	3.5%
Other values (37)	1468	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2043	22.8%
0.083333	677	7.6%
0.090909	43	0.5%
0.1	27	0.3%
0.111111	18	0.2%

Value	Count	Frequency (%)
1	2178	24.3%
0.916667	396	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%

ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct count	47
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.202457683575419
Minimum	0.0
Maximum	1.0
Zeros	4302
Zeros (%)	48.1%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2983360652
Coefficient of variation (CV)	1.473572452
Kurtosis	1.161845601
Mean	0.2024576836
Median Absolute Deviation (MAD)	0.083333
Skewness	1.535612784
Sum	1811.996268
Variance	0.08900440779

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	418	4.7%
0.333333	355	4.0%
0.416667	244	2.7%
0.5	235	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	855	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.090909	56	0.6%
0.1	39	0.4%
0.111111	26	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%

PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct count	47
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3644373415642458
Minimum	0.0
Maximum	1.0
Zeros	3915
Zeros (%)	43.7%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.3974477797
Coefficient of variation (CV)	1.090579187
Kurtosis	-1.398632185
Mean	0.3644373416
Median Absolute Deviation (MAD)	0.166667
Skewness	0.509201165
Sum	3261.714207
Variance	0.1579647376

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3915	43.7%
1	1331	14.9%
0.416667	388	4.3%
0.916667	345	3.9%
0.833333	311	3.5%
0.5	310	3.5%
0.166667	305	3.4%
0.666667	292	3.3%
0.75	291	3.3%
0.083333	275	3.1%
Other values (37)	1187	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3915	43.7%
0.083333	275	3.1%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%

Value	Count	Frequency (%)
1	1331	14.9%
0.916667	345	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%

CASH_ADVANCE_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct count	54
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.13514420033519556
Minimum	0.0
Maximum	1.5
Zeros	4628
Zeros (%)	51.7%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.2001213881
Coefficient of variation (CV)	1.480798937
Kurtosis	3.334734328
Mean	0.1351442003
Median Absolute Deviation (MAD)	0
Skewness	1.828686266
Sum	1209.540593
Variance	0.04004856999

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.166667	759	8.5%
0.25	578	6.5%
0.333333	439	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	142	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (44)	700	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%

CASH_ADVANCE_TRX
Real number (ℝ_≥0)

ZEROS

Distinct count	65
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.2488268156424582
Minimum	0
Maximum	123
Zeros	4628
Zeros (%)	51.7%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.824646744
Coefficient of variation (CV)	2.100649598
Kurtosis	61.64686248
Mean	3.248826816
Median Absolute Deviation (MAD)	0
Skewness	5.721298203
Sum	29077
Variance	46.57580318

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
10	150	1.7%
Other values (55)	915	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%

PURCHASES_TRX
Real number (ℝ_≥0)

ZEROS

Distinct count	173
Unique (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	14.709832402234637
Minimum	0
Maximum	358
Zeros	2044
Zeros (%)	22.8%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.85764911
Coefficient of variation (CV)	1.689866236
Kurtosis	34.79310026
Mean	14.7098324
Median Absolute Deviation (MAD)	7
Skewness	4.630655266
Sum	131653
Variance	617.9027193

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
12	570	6.4%
2	379	4.2%
6	352	3.9%
3	314	3.5%
4	285	3.2%
7	275	3.1%
8	267	3.0%
5	267	3.0%
Other values (163)	3530	39.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
2	379	4.2%
3	314	3.5%
4	285	3.2%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%

CREDIT_LIMIT
Real number (ℝ_≥0)

Distinct count	205
Unique (%)	2.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	4494.449450364621
Minimum	50.0
Maximum	30000.0
Zeros	0
Zeros (%)	0.0%
Memory size	69.9 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.815725
Coefficient of variation (CV)	0.8096243524
Kurtosis	2.836655932
Mean	4494.44945
Median Absolute Deviation (MAD)	1800
Skewness	1.522464005
Sum	40220828.13
Variance	13240979.88

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3000	784	8.8%
1500	722	8.1%
1200	621	6.9%
1000	614	6.9%
2500	612	6.8%
4000	506	5.7%
6000	463	5.2%
5000	389	4.3%
2000	371	4.1%
7500	277	3.1%
Other values (195)	3590	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%

PAYMENTS
Real number (ℝ_≥0)

ZEROS

Distinct count	8711
Unique (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1733.1438520248043
Minimum	0.0
Maximum	50721.483360000006
Zeros	240
Zeros (%)	2.7%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	89.98892395
Q1	383.276166
median	856.901546
Q3	1901.134317
95-th percentile	6082.090595
Maximum	50721.48336
Range	50721.48336
Interquartile range (IQR)	1517.858151

Descriptive statistics

Standard deviation	2895.063757
Coefficient of variation (CV)	1.670411693
Kurtosis	54.77073581
Mean	1733.143852
Median Absolute Deviation (MAD)	581.3514605
Skewness	5.907619794
Sum	15511637.48
Variance	8381394.157

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	240	2.7%
806.587482	1	< 0.1%
836.812414	1	< 0.1%
139.607827	1	< 0.1%
107.242408	1	< 0.1%
433.860714	1	< 0.1%
402.20014	1	< 0.1%
308.886492	1	< 0.1%
238.695115	1	< 0.1%
197.86349	1	< 0.1%
Other values (8701)	8701	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%

MINIMUM_PAYMENTS
Real number (ℝ_≥0)

MISSING

Distinct count	8636
Unique (%)	> 99.9%
Missing	313
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%

Mean	864.2065423050827
Minimum	0.019163
Maximum	76406.20752000001
Zeros	0
Zeros (%)	0.0%
Memory size	69.9 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	73.2820058
Q1	169.123707
median	312.343947
Q3	825.485459
95-th percentile	2766.56331
Maximum	76406.20752
Range	76406.18836
Interquartile range (IQR)	656.361752

Descriptive statistics

Standard deviation	2372.446607
Coefficient of variation (CV)	2.745231019
Kurtosis	283.9899859
Mean	864.2065423
Median Absolute Deviation (MAD)	190.374096
Skewness	13.62279699
Sum	7464151.906
Variance	5628502.901

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
299.351881	2	< 0.1%
284.70693	1	< 0.1%
144.641814	1	< 0.1%
1927.887547	1	< 0.1%
6825.44203	1	< 0.1%
342.412476	1	< 0.1%
5583.630482	1	< 0.1%
125.3494	1	< 0.1%
3.19794	1	< 0.1%
140.596138	1	< 0.1%
Other values (8626)	8626	96.4%
(Missing)	313	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%

PRC_FULL_PAYMENT
Real number (ℝ_≥0)

ZEROS

Distinct count	47
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.15371464849162012
Minimum	0.0
Maximum	1.0
Zeros	5903
Zeros (%)	66.0%
Memory size	69.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2924991962
Coefficient of variation (CV)	1.902871321
Kurtosis	2.432395301
Mean	0.1537146485
Median Absolute Deviation (MAD)	0
Skewness	1.942819941
Sum	1375.746104
Variance	0.0855557798

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5903	66.0%
1	488	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.25	156	1.7%
0.5	156	1.7%
0.090909	153	1.7%
0.333333	134	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1191	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5903	66.0%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%

Value	Count	Frequency (%)
1	488	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%

TENURE
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.51731843575419
Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	69.9 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.338330769
Coefficient of variation (CV)	0.1162015947
Kurtosis	7.694823186
Mean	11.51731844
Median Absolute Deviation (MAD)	0
Skewness	-2.943017288
Sum	103080
Variance	1.791129248

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
6	204	2.3%
8	196	2.2%
7	190	2.1%
9	175	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	204	2.3%
7	190	2.1%
8	196	2.2%
9	175	2.0%
10	236	2.6%

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
9	175	2.0%
8	196	2.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
0	C10001	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.000000	0	2	1000.0	201.802084	139.509787	0.000000	12
1	C10002	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.250000	4	0	7000.0	4103.032597	1072.340217	0.222222	12
2	C10003	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.000000	0	12	7500.0	622.066742	627.284787	0.000000	12
3	C10004	1666.670542	0.636364	1499.00	1499.00	0.00	205.788017	0.083333	0.083333	0.000000	0.083333	1	1	7500.0	0.000000	NaN	0.000000	12
4	C10005	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.000000	0	1	1200.0	678.334763	244.791237	0.000000	12
5	C10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.000000	0	8	1800.0	1400.057770	2407.246035	0.000000	12
6	C10007	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.000000	0	64	13500.0	6354.314328	198.065894	1.000000	12
7	C10008	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.000000	0	12	2300.0	679.065082	532.033990	0.000000	12
8	C10009	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.000000	0	5	7000.0	688.278568	311.963409	0.000000	12
9	C10010	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	3	11000.0	1164.770591	100.302262	0.000000	12

Last rows

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
8940	C19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.00	6
8941	C19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.00	6
8942	C19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.25	6
8943	C19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.00	6
8944	C19185	193.571722	0.833333	1012.73	1012.73	0.00	0.000000	0.333333	0.333333	0.000000	0.000000	0	2	4000.0	0.000000	NaN	0.00	6
8945	C19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.50	6
8946	C19187	19.183215	1.000000	300.00	0.00	300.00	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	275.861322	NaN	0.00	6
8947	C19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.25	6
8948	C19189	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.25	6
8949	C19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.00	6

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows